SchoolStatus 
EntityType  Independent 
Logical Entity Name  SchoolStatus 
Default Table Name  SySchoolStatus 
Logical Only  NO 
Definition 
 
Note 
 

SchoolStatus Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
SchoolStatusId(PK)    INTEGER  NO 
 
Code    CHAR(8)  NO 
 
Name    VARCHAR(35)  NO 
 
CampusGroupId    INTEGER  NO 
 
SystemSchoolStatusId    INTEGER  NO 
 
IsSystemCode    BIT  NO 
 
IsActive    BIT  NO 
 
ModFlag    CHAR(1)  NO 
 
LastModifiedUserId    INTEGER  NO 
 
CreatedDateTime    DATETIME  NO 
 
LastModifiedDateTime    DATETIME  NO 
 
RowVersion    TIMESTAMP/DATE  NO 
 
NSLDSStatus    CHAR(1)  YES 
 
IsExcludedCrmIntegration    BIT  NO 
 

SchoolStatus Keys 
Key Name  Key Type  Keys 
SySchoolStatus_SyCampusGrpID_N_N_IDX  Inversion Entry  CampusGroupId 
SySchoolStatus_SySchoolStatusID_U_C_IDX  PrimaryKey  SchoolStatusId 
SySchoolStatus_SyStatusID_N_N_IDX  Inversion Entry  SystemSchoolStatusId 

SchoolStatus Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
SchoolStatusChangeReason  Non-Specific            NO 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype 
JobType  Non-Identifying  One To Zero or More          NO 
StudentEnrollmentPeriod  Non-Identifying  One To Zero or More          NO 
AdEnrollTermRelationshipException  Non-Identifying  One To Zero or More          NO 
FaSapTable  Non-Identifying  One To Zero or More          NO 
DisbursementApprovalRuleSchoolStatusList  Identifying  One To Zero or More          NO 
HsRoomMateMatchStudentStatus  Non-Identifying  One To Zero or More          NO 
PlEmploymentStatusExternalMap  Non-Identifying  One To Zero or More          NO 
StudentPlacementSummaryInSchoolDetail  Non-Identifying  One To Zero or More          NO 
SyCrmSchoolStatus  Non-Identifying  One To Zero or More          NO 
sySchoolStatusExternalMap  Non-Identifying  One To Zero or More          NO 
StudentPlacementStatusHistory  Non-Identifying  One To Zero or More          NO 
PendingApplicantSchoolStatusHistory  Non-Identifying  One To Zero or More          NO 
StudentSchoolStatusHistory  Non-Identifying  One To Zero or More          NO 
StudentPlacementStatusHistory  Non-Identifying  One To Zero or More          NO 
StudentPlacementSummary  Non-Identifying  One To Zero or More          NO 
PendingApplicantSchoolStatusHistory  Non-Identifying  One To Zero or More          NO 
StudentSchoolStatusHistory  Non-Identifying  One To Zero or More          NO 
PlacementStatusReason  Non-Identifying  One To Zero or More          NO 
ProspectInquiry  Non-Identifying  One To Zero or More          NO 
SchoolStatusChangeReason  Non-Identifying  One To Zero or More          NO 
Student  Non-Identifying  One To Zero or More          NO 
StudentEnrollmentPeriod  Non-Identifying  One To Zero or More          NO 
StudentPlacementSummaryInSchoolDetail  Non-Identifying  One To Zero or More          NO 

SchoolStatus Check Constraints 
Check Constraint Name  CheckConstraint